Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 242559 |
| Missing cells | 1924222 |
| Missing cells (%) | 36.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 56.4 MiB |
| Average record size in memory | 244.0 B |
Variable types
| NUM | 12 |
|---|---|
| UNSUPPORTED | 7 |
| CAT | 2 |
| BOOL | 1 |
operation_car has constant value "242559" | Constant |
operation_date has a high cardinality: 25383 distinct values | High cardinality |
index_train has 242559 (100.0%) missing values | Missing |
danger has 223763 (92.3%) missing values | Missing |
loaded has 242559 (100.0%) missing values | Missing |
operation_train has 242559 (100.0%) missing values | Missing |
rod_train has 242559 (100.0%) missing values | Missing |
ssp_station_esr has 242559 (100.0%) missing values | Missing |
ssp_station_id has 242559 (100.0%) missing values | Missing |
weight_brutto has 242559 (100.0%) missing values | Missing |
adm is highly skewed (γ1 = 26.46248648) | Skewed |
operation_st_id is highly skewed (γ1 = 27.18052782) | Skewed |
df_index has unique values | Unique |
index_train is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
loaded is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
operation_train is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
rod_train is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ssp_station_esr is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ssp_station_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
weight_brutto is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
receiver has 55854 (23.0%) zeros | Zeros |
sender has 33571 (13.8%) zeros | Zeros |
Reproduction
| Analysis started | 2021-04-14 19:46:51.261742 |
|---|---|
| Analysis finished | 2021-04-14 19:47:48.078970 |
| Duration | 56.82 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 242559 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1941370.804 |
|---|---|
| Minimum | 5 |
| Maximum | 4189902 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 199585.5 |
| Q1 | 952495 |
| median | 1850939 |
| Q3 | 2793773.5 |
| 95-th percentile | 4029769.5 |
| Maximum | 4189902 |
| Range | 4189897 |
| Interquartile range (IQR) | 1841278.5 |
Descriptive statistics
| Standard deviation | 1166537.77 |
|---|---|
| Coefficient of variation (CV) | 0.6008835443 |
| Kurtosis | -0.9912977725 |
| Mean | 1941370.804 |
| Median Absolute Deviation (MAD) | 919207 |
| Skewness | 0.2148600901 |
| Sum | 4.708969609e+11 |
| Variance | 1.360810368e+12 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) | |
| 3497996 | 1 | < 0.1% | |
| 3871945 | 1 | < 0.1% | |
| 2675889 | 1 | < 0.1% | |
| 1098931 | 1 | < 0.1% | |
| 3730614 | 1 | < 0.1% | |
| 166444 | 1 | < 0.1% | |
| 562361 | 1 | < 0.1% | |
| 2655419 | 1 | < 0.1% | |
| 2667709 | 1 | < 0.1% | |
| 2141374 | 1 | < 0.1% | |
| 2139327 | 1 | < 0.1% | |
| 4093643 | 1 | < 0.1% | |
| 228548 | 1 | < 0.1% | |
| 1799365 | 1 | < 0.1% | |
| 1772746 | 1 | < 0.1% | |
| 3681454 | 1 | < 0.1% | |
| 3343563 | 1 | < 0.1% | |
| 438700 | 1 | < 0.1% | |
| 3876047 | 1 | < 0.1% | |
| 554842 | 1 | < 0.1% | |
| 940776 | 1 | < 0.1% | |
| 2358484 | 1 | < 0.1% | |
| 152801 | 1 | < 0.1% | |
| 3833060 | 1 | < 0.1% | |
| 158950 | 1 | < 0.1% | |
| Other values (242534) | 242534 | > 99.9% |
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 27 | 1 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 51 | 1 | < 0.1% | |
| 52 | 1 | < 0.1% | |
| 69 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4189902 | 1 | < 0.1% | |
| 4189887 | 1 | < 0.1% | |
| 4189884 | 1 | < 0.1% | |
| 4189873 | 1 | < 0.1% | |
| 4189871 | 1 | < 0.1% | |
| 4189851 | 1 | < 0.1% | |
| 4189849 | 1 | < 0.1% | |
| 4189847 | 1 | < 0.1% | |
| 4189845 | 1 | < 0.1% | |
| 4189827 | 1 | < 0.1% |
length
Real number (ℝ≥0)
| Distinct | 48 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.076795996 |
|---|---|
| Minimum | 0.79 |
| Maximum | 2.13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 0.79 |
|---|---|
| 5-th percentile | 0.87 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1.82 |
| Maximum | 2.13 |
| Range | 1.34 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.244850207 |
|---|---|
| Coefficient of variation (CV) | 0.227387739 |
| Kurtosis | 4.82369406 |
| Mean | 1.076795996 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.478727108 |
| Sum | 261186.56 |
| Variance | 0.05995162384 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 176254 | 72.7% | |
| 0.87 | 19218 | 7.9% | |
| 1.06 | 13818 | 5.7% | |
| 1.82 | 10636 | 4.4% | |
| 1.85 | 6341 | 2.6% | |
| 1.41 | 6166 | 2.5% | |
| 1.83 | 2758 | 1.1% | |
| 1.22 | 1045 | 0.4% | |
| 0.83 | 833 | 0.3% | |
| 1.36 | 829 | 0.3% | |
| 0.86 | 543 | 0.2% | |
| 1.11 | 416 | 0.2% | |
| 1.01 | 381 | 0.2% | |
| 0.79 | 360 | 0.1% | |
| 1.6 | 343 | 0.1% | |
| 1.89 | 336 | 0.1% | |
| 0.85 | 329 | 0.1% | |
| 1.27 | 262 | 0.1% | |
| 1.32 | 223 | 0.1% | |
| 1.23 | 193 | 0.1% | |
| 1.42 | 190 | 0.1% | |
| 1.05 | 165 | 0.1% | |
| 1.2 | 163 | 0.1% | |
| 1.35 | 158 | 0.1% | |
| 1.03 | 152 | 0.1% | |
| Other values (23) | 447 | 0.2% |
| Value | Count | Frequency (%) | |
| 0.79 | 360 | 0.1% | |
| 0.83 | 833 | 0.3% | |
| 0.85 | 329 | 0.1% | |
| 0.86 | 543 | 0.2% | |
| 0.87 | 19218 | 7.9% | |
| 0.88 | 1 | < 0.1% | |
| 0.9 | 1 | < 0.1% | |
| 0.92 | 15 | < 0.1% | |
| 0.95 | 21 | < 0.1% | |
| 0.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2.13 | 46 | < 0.1% | |
| 1.92 | 30 | < 0.1% | |
| 1.89 | 336 | 0.1% | |
| 1.85 | 6341 | 2.6% | |
| 1.84 | 58 | < 0.1% | |
| 1.83 | 2758 | 1.1% | |
| 1.82 | 10636 | 4.4% | |
| 1.81 | 1 | < 0.1% | |
| 1.78 | 2 | < 0.1% | |
| 1.77 | 17 | < 0.1% |
car_number
Real number (ℝ≥0)
| Distinct | 201622 |
|---|---|
| Distinct (%) | 83.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62898482.06 |
|---|---|
| Minimum | 24107542 |
| Maximum | 98099997 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 24107542 |
|---|---|
| 5-th percentile | 51594265 |
| Q1 | 54968421 |
| median | 60914074 |
| Q3 | 63727609.5 |
| 95-th percentile | 94654894 |
| Maximum | 98099997 |
| Range | 73992455 |
| Interquartile range (IQR) | 8759188.5 |
Descriptive statistics
| Standard deviation | 12807543.8 |
|---|---|
| Coefficient of variation (CV) | 0.2036224625 |
| Kurtosis | 2.051961618 |
| Mean | 62898482.06 |
| Median Absolute Deviation (MAD) | 4821314 |
| Skewness | 1.45274081 |
| Sum | 1.525659291e+13 |
| Variance | 1.640331783e+14 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 52480407 | 14 | < 0.1% | |
| 64235385 | 13 | < 0.1% | |
| 64939937 | 13 | < 0.1% | |
| 63479570 | 13 | < 0.1% | |
| 64903214 | 13 | < 0.1% | |
| 52480969 | 13 | < 0.1% | |
| 63514616 | 13 | < 0.1% | |
| 62438056 | 12 | < 0.1% | |
| 52480027 | 12 | < 0.1% | |
| 54110176 | 12 | < 0.1% | |
| 52480233 | 12 | < 0.1% | |
| 62143649 | 12 | < 0.1% | |
| 63310635 | 12 | < 0.1% | |
| 63010144 | 12 | < 0.1% | |
| 52480324 | 12 | < 0.1% | |
| 55084396 | 11 | < 0.1% | |
| 63642854 | 11 | < 0.1% | |
| 63476006 | 11 | < 0.1% | |
| 63373203 | 11 | < 0.1% | |
| 62449905 | 11 | < 0.1% | |
| 63423776 | 11 | < 0.1% | |
| 63901888 | 11 | < 0.1% | |
| 56184864 | 11 | < 0.1% | |
| 54110028 | 11 | < 0.1% | |
| 55084560 | 11 | < 0.1% | |
| Other values (201597) | 242261 | 99.9% |
| Value | Count | Frequency (%) | |
| 24107542 | 1 | < 0.1% | |
| 24273559 | 1 | < 0.1% | |
| 24293821 | 1 | < 0.1% | |
| 24321838 | 1 | < 0.1% | |
| 24345670 | 1 | < 0.1% | |
| 24467441 | 1 | < 0.1% | |
| 24576373 | 1 | < 0.1% | |
| 24576506 | 1 | < 0.1% | |
| 24590523 | 1 | < 0.1% | |
| 24593485 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 98099997 | 1 | < 0.1% | |
| 98099989 | 1 | < 0.1% | |
| 98099971 | 1 | < 0.1% | |
| 98099963 | 1 | < 0.1% | |
| 98099955 | 1 | < 0.1% | |
| 98099948 | 1 | < 0.1% | |
| 98099930 | 1 | < 0.1% | |
| 98099922 | 1 | < 0.1% | |
| 98099914 | 1 | < 0.1% | |
| 98099906 | 1 | < 0.1% |
destination_esr
Real number (ℝ≥0)
| Distinct | 1190 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 2366 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 699123.7066 |
|---|---|
| Minimum | 10002 |
| Maximum | 997502 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 10002 |
|---|---|
| 5-th percentile | 35902 |
| Q1 | 467004 |
| median | 864601 |
| Q3 | 967808 |
| 95-th percentile | 986103 |
| Maximum | 997502 |
| Range | 987500 |
| Interquartile range (IQR) | 500804 |
Descriptive statistics
| Standard deviation | 347089.5501 |
|---|---|
| Coefficient of variation (CV) | 0.4964637114 |
| Kurtosis | -0.7118203195 |
| Mean | 699123.7066 |
| Median Absolute Deviation (MAD) | 117501 |
| Skewness | -0.9848874575 |
| Sum | 1.679246205e+11 |
| Variance | 1.204711558e+11 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 986103 | 21625 | 8.9% | |
| 76404 | 17779 | 7.3% | |
| 967808 | 16942 | 7.0% | |
| 864207 | 7784 | 3.2% | |
| 18502 | 5720 | 2.4% | |
| 947005 | 5601 | 2.3% | |
| 984700 | 4766 | 2.0% | |
| 864601 | 4280 | 1.8% | |
| 860206 | 3992 | 1.6% | |
| 592204 | 3853 | 1.6% | |
| 987801 | 3301 | 1.4% | |
| 985702 | 3283 | 1.4% | |
| 980200 | 2967 | 1.2% | |
| 937304 | 2926 | 1.2% | |
| 20706 | 2578 | 1.1% | |
| 989309 | 2499 | 1.0% | |
| 817600 | 2270 | 0.9% | |
| 60001 | 2256 | 0.9% | |
| 985505 | 2208 | 0.9% | |
| 191000 | 2123 | 0.9% | |
| 183502 | 2058 | 0.8% | |
| 467004 | 2005 | 0.8% | |
| 932207 | 1998 | 0.8% | |
| 924605 | 1965 | 0.8% | |
| 871906 | 1880 | 0.8% | |
| Other values (1165) | 111534 | 46.0% | |
| (Missing) | 2366 | 1.0% |
| Value | Count | Frequency (%) | |
| 10002 | 2 | < 0.1% | |
| 10303 | 16 | < 0.1% | |
| 11804 | 3 | < 0.1% | |
| 13000 | 1 | < 0.1% | |
| 14906 | 170 | 0.1% | |
| 15400 | 5 | < 0.1% | |
| 15701 | 461 | 0.2% | |
| 16009 | 405 | 0.2% | |
| 16403 | 22 | < 0.1% | |
| 17001 | 37 | < 0.1% |
| Value | Count | Frequency (%) | |
| 997502 | 11 | < 0.1% | |
| 994805 | 1 | < 0.1% | |
| 993304 | 11 | < 0.1% | |
| 991205 | 24 | < 0.1% | |
| 991101 | 62 | < 0.1% | |
| 990700 | 52 | < 0.1% | |
| 990607 | 1 | < 0.1% | |
| 990005 | 3 | < 0.1% | |
| 989309 | 2499 | 1.0% | |
| 989205 | 1 | < 0.1% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.04017167 |
|---|---|
| Minimum | 20 |
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 20 |
| median | 20 |
| Q3 | 20 |
| 95-th percentile | 20 |
| Maximum | 99 |
| Range | 79 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5198687065 |
|---|---|
| Coefficient of variation (CV) | 0.02594133 |
| Kurtosis | 2442.579832 |
| Mean | 20.04017167 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.46248648 |
| Sum | 4860924 |
| Variance | 0.270263472 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 20 | 240847 | 99.3% | |
| 26 | 1318 | 0.5% | |
| 27 | 203 | 0.1% | |
| 21 | 157 | 0.1% | |
| 25 | 16 | < 0.1% | |
| 24 | 14 | < 0.1% | |
| 22 | 2 | < 0.1% | |
| 99 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20 | 240847 | 99.3% | |
| 21 | 157 | 0.1% | |
| 22 | 2 | < 0.1% | |
| 24 | 14 | < 0.1% | |
| 25 | 16 | < 0.1% | |
| 26 | 1318 | 0.5% | |
| 27 | 203 | 0.1% | |
| 59 | 1 | < 0.1% | |
| 99 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% | |
| 27 | 203 | 0.1% | |
| 26 | 1318 | 0.5% | |
| 25 | 16 | < 0.1% | |
| 24 | 14 | < 0.1% | |
| 22 | 2 | < 0.1% | |
| 21 | 157 | 0.1% | |
| 20 | 240847 | 99.3% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 223763 |
| Missing (%) | 92.3% |
| Memory size | 1.9 MiB |
| 1 | 18796 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 18796 | 7.7% | |
| (Missing) | 223763 | 92.3% |
gruz
Real number (ℝ≥0)
| Distinct | 348 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 60 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 163058.4186 |
|---|---|
| Minimum | 3009 |
| Maximum | 757325 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 3009 |
|---|---|
| 5-th percentile | 3009 |
| Q1 | 161043 |
| median | 161128 |
| Q3 | 161170 |
| 95-th percentile | 331016 |
| Maximum | 757325 |
| Range | 754316 |
| Interquartile range (IQR) | 127 |
Descriptive statistics
| Standard deviation | 91787.19135 |
|---|---|
| Coefficient of variation (CV) | 0.5629098584 |
| Kurtosis | 8.637154073 |
| Mean | 163058.4186 |
| Median Absolute Deviation (MAD) | 57 |
| Skewness | 1.649320022 |
| Sum | 3.954150346e+10 |
| Variance | 8424888496 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 161128 | 69691 | 28.7% | |
| 3009 | 28925 | 11.9% | |
| 161043 | 18983 | 7.8% | |
| 161185 | 14835 | 6.1% | |
| 161113 | 13762 | 5.7% | |
| 161170 | 10826 | 4.5% | |
| 161096 | 10512 | 4.3% | |
| 391498 | 6388 | 2.6% | |
| 141092 | 6185 | 2.5% | |
| 161147 | 6102 | 2.5% | |
| 214039 | 5632 | 2.3% | |
| 161016 | 4840 | 2.0% | |
| 161132 | 3998 | 1.6% | |
| 171030 | 3968 | 1.6% | |
| 211056 | 3223 | 1.3% | |
| 221066 | 2709 | 1.1% | |
| 91118 | 2125 | 0.9% | |
| 281048 | 1564 | 0.6% | |
| 161151 | 1450 | 0.6% | |
| 236038 | 1401 | 0.6% | |
| 81188 | 1335 | 0.6% | |
| 331016 | 1248 | 0.5% | |
| 151060 | 1236 | 0.5% | |
| 232431 | 1159 | 0.5% | |
| 161062 | 1103 | 0.5% | |
| Other values (323) | 19299 | 8.0% |
| Value | Count | Frequency (%) | |
| 3009 | 28925 | 11.9% | |
| 11005 | 223 | 0.1% | |
| 13000 | 2 | < 0.1% | |
| 14003 | 17 | < 0.1% | |
| 15006 | 13 | < 0.1% | |
| 18023 | 74 | < 0.1% | |
| 18108 | 13 | < 0.1% | |
| 18112 | 1 | < 0.1% | |
| 21079 | 1 | < 0.1% | |
| 41123 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 757325 | 2 | < 0.1% | |
| 754115 | 1 | < 0.1% | |
| 731062 | 3 | < 0.1% | |
| 726079 | 1 | < 0.1% | |
| 725502 | 150 | 0.1% | |
| 721484 | 321 | 0.1% | |
| 711459 | 33 | < 0.1% | |
| 711444 | 19 | < 0.1% | |
| 711285 | 7 | < 0.1% | |
| 711035 | 26 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
| 10 |
|---|
| Value | Count | Frequency (%) | |
| 10 | 242559 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 485118 | 50.0% | |
| 1 | 242559 | 25.0% | |
| . | 242559 | 25.0% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 727677 | 75.0% | |
| Other Punctuation | 242559 | 25.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 485118 | 66.7% | |
| 1 | 242559 | 33.3% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 242559 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 970236 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 485118 | 50.0% | |
| 1 | 242559 | 25.0% | |
| . | 242559 | 25.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 970236 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 485118 | 50.0% | |
| 1 | 242559 | 25.0% | |
| . | 242559 | 25.0% |
| Distinct | 25383 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
| 2020-07-30 16:42:00 | 220 |
|---|---|
| 2020-07-18 16:52:00 | 195 |
| 2020-07-25 16:11:00 | 171 |
| 2020-07-29 16:54:00 | 171 |
| 2020-07-20 09:06:00 | 168 |
| Other values (25378) |
| Value | Count | Frequency (%) | |
| 2020-07-30 16:42:00 | 220 | 0.1% | |
| 2020-07-18 16:52:00 | 195 | 0.1% | |
| 2020-07-25 16:11:00 | 171 | 0.1% | |
| 2020-07-29 16:54:00 | 171 | 0.1% | |
| 2020-07-20 09:06:00 | 168 | 0.1% | |
| 2020-07-16 16:43:00 | 165 | 0.1% | |
| 2020-07-23 16:38:00 | 163 | 0.1% | |
| 2020-07-25 17:07:00 | 159 | 0.1% | |
| 2020-07-31 18:24:00 | 159 | 0.1% | |
| 2020-07-17 17:30:00 | 157 | 0.1% | |
| 2020-07-20 16:10:00 | 157 | 0.1% | |
| 2020-07-22 08:39:00 | 153 | 0.1% | |
| 2020-07-17 16:58:00 | 153 | 0.1% | |
| 2020-07-16 15:08:00 | 153 | 0.1% | |
| 2020-07-30 16:19:00 | 150 | 0.1% | |
| 2020-07-29 16:56:00 | 150 | 0.1% | |
| 2020-07-29 16:59:00 | 149 | 0.1% | |
| 2020-07-28 16:51:00 | 147 | 0.1% | |
| 2020-07-17 15:10:00 | 145 | 0.1% | |
| 2020-07-30 16:47:00 | 145 | 0.1% | |
| 2020-07-18 10:20:00 | 144 | 0.1% | |
| 2020-07-19 17:07:00 | 143 | 0.1% | |
| 2020-07-23 13:37:00 | 143 | 0.1% | |
| 2020-07-22 08:32:00 | 141 | 0.1% | |
| 2020-07-23 16:19:00 | 139 | 0.1% | |
| Other values (25358) | 238619 | 98.4% |
Unique
| Unique | 7954 ? |
|---|---|
| Unique (%) | 3.3% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 1417454 | 30.8% | |
| 2 | 723344 | 15.7% | |
| - | 485118 | 10.5% | |
| : | 485118 | 10.5% | |
| 1 | 342773 | 7.4% | |
| 7 | 325707 | 7.1% | |
| 242559 | 5.3% | ||
| 3 | 127467 | 2.8% | |
| 5 | 116137 | 2.5% | |
| 4 | 97703 | 2.1% | |
| 6 | 95118 | 2.1% | |
| 9 | 75153 | 1.6% | |
| 8 | 74970 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 3395826 | 73.7% | |
| Dash Punctuation | 485118 | 10.5% | |
| Other Punctuation | 485118 | 10.5% | |
| Space Separator | 242559 | 5.3% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 1417454 | 41.7% | |
| 2 | 723344 | 21.3% | |
| 1 | 342773 | 10.1% | |
| 7 | 325707 | 9.6% | |
| 3 | 127467 | 3.8% | |
| 5 | 116137 | 3.4% | |
| 4 | 97703 | 2.9% | |
| 6 | 95118 | 2.8% | |
| 9 | 75153 | 2.2% | |
| 8 | 74970 | 2.2% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 485118 | 100.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 242559 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| : | 485118 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 4608621 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 1417454 | 30.8% | |
| 2 | 723344 | 15.7% | |
| - | 485118 | 10.5% | |
| : | 485118 | 10.5% | |
| 1 | 342773 | 7.4% | |
| 7 | 325707 | 7.1% | |
| 242559 | 5.3% | ||
| 3 | 127467 | 2.8% | |
| 5 | 116137 | 2.5% | |
| 4 | 97703 | 2.1% | |
| 6 | 95118 | 2.1% | |
| 9 | 75153 | 1.6% | |
| 8 | 74970 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 4608621 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 1417454 | 30.8% | |
| 2 | 723344 | 15.7% | |
| - | 485118 | 10.5% | |
| : | 485118 | 10.5% | |
| 1 | 342773 | 7.4% | |
| 7 | 325707 | 7.1% | |
| 242559 | 5.3% | ||
| 3 | 127467 | 2.8% | |
| 5 | 116137 | 2.5% | |
| 4 | 97703 | 2.1% | |
| 6 | 95118 | 2.1% | |
| 9 | 75153 | 1.6% | |
| 8 | 74970 | 1.6% |
operation_st_esr
Real number (ℝ≥0)
| Distinct | 329 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 890745.2695 |
|---|---|
| Minimum | 831203 |
| Maximum | 998100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 831203 |
|---|---|
| 5-th percentile | 852708 |
| Q1 | 863007 |
| median | 871906 |
| Q3 | 924501 |
| 95-th percentile | 980200 |
| Maximum | 998100 |
| Range | 166897 |
| Interquartile range (IQR) | 61494 |
Descriptive statistics
| Standard deviation | 38944.25544 |
|---|---|
| Coefficient of variation (CV) | 0.04372097925 |
| Kurtosis | -0.04579097477 |
| Mean | 890745.2695 |
| Median Absolute Deviation (MAD) | 11903 |
| Skewness | 1.044461844 |
| Sum | 2.160582818e+11 |
| Variance | 1516655032 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 863007 | 20031 | 8.3% | |
| 937906 | 10887 | 4.5% | |
| 887603 | 9603 | 4.0% | |
| 887904 | 8850 | 3.6% | |
| 862201 | 7999 | 3.3% | |
| 864902 | 7904 | 3.3% | |
| 862108 | 7882 | 3.2% | |
| 932207 | 6178 | 2.5% | |
| 864705 | 5218 | 2.2% | |
| 864809 | 4895 | 2.0% | |
| 947005 | 4691 | 1.9% | |
| 980200 | 4215 | 1.7% | |
| 986103 | 4137 | 1.7% | |
| 871802 | 3905 | 1.6% | |
| 862606 | 3558 | 1.5% | |
| 872701 | 3495 | 1.4% | |
| 852708 | 3414 | 1.4% | |
| 871304 | 3314 | 1.4% | |
| 862305 | 3093 | 1.3% | |
| 831504 | 3093 | 1.3% | |
| 892103 | 2973 | 1.2% | |
| 863100 | 2969 | 1.2% | |
| 970406 | 2858 | 1.2% | |
| 863702 | 2831 | 1.2% | |
| 889007 | 2757 | 1.1% | |
| Other values (304) | 101809 | 42.0% |
| Value | Count | Frequency (%) | |
| 831203 | 374 | 0.2% | |
| 831400 | 40 | < 0.1% | |
| 831504 | 3093 | 1.3% | |
| 831608 | 3 | < 0.1% | |
| 833603 | 4 | < 0.1% | |
| 834108 | 1 | < 0.1% | |
| 836103 | 3 | < 0.1% | |
| 837303 | 1 | < 0.1% | |
| 837604 | 8 | < 0.1% | |
| 837708 | 64 | < 0.1% |
| Value | Count | Frequency (%) | |
| 998100 | 5 | < 0.1% | |
| 997502 | 1 | < 0.1% | |
| 995403 | 56 | < 0.1% | |
| 994805 | 6 | < 0.1% | |
| 993304 | 9 | < 0.1% | |
| 991101 | 4 | < 0.1% | |
| 989309 | 199 | 0.1% | |
| 989205 | 118 | < 0.1% | |
| 989008 | 8 | < 0.1% | |
| 988804 | 7 | < 0.1% |
| Distinct | 329 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2268180094 |
|---|---|
| Minimum | 2000035090 |
| Maximum | 2.000800023e+11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 2000035090 |
|---|---|
| 5-th percentile | 2000035530 |
| Q1 | 2000037064 |
| median | 2001930776 |
| Q3 | 2001931256 |
| 95-th percentile | 2002025275 |
| Maximum | 2.000800023e+11 |
| Range | 1.980799672e+11 |
| Interquartile range (IQR) | 1894192 |
Descriptive statistics
| Standard deviation | 7267938794 |
|---|---|
| Coefficient of variation (CV) | 3.204304109 |
| Kurtosis | 736.7871799 |
| Mean | 2268180094 |
| Median Absolute Deviation (MAD) | 2746 |
| Skewness | 27.18052782 |
| Sum | 5.501674954e+14 |
| Variance | 5.282293432e+19 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2001933494 | 20031 | 8.3% | |
| 2000037532 | 10887 | 4.5% | |
| 2000035530 | 9603 | 4.0% | |
| 2000035564 | 8850 | 3.6% | |
| 2001930776 | 7999 | 3.3% | |
| 2000039908 | 7904 | 3.3% | |
| 2001930794 | 7882 | 3.2% | |
| 2000037064 | 6178 | 2.5% | |
| 2001933502 | 5218 | 2.2% | |
| 2001930822 | 4895 | 2.0% | |
| 2002025275 | 4691 | 1.9% | |
| 2002025607 | 4215 | 1.7% | |
| 2002025661 | 4137 | 1.7% | |
| 2001933522 | 3905 | 1.6% | |
| 2001930782 | 3558 | 1.5% | |
| 2001931256 | 3495 | 1.4% | |
| 2001930734 | 3414 | 1.4% | |
| 2001930872 | 3314 | 1.4% | |
| 2001930778 | 3093 | 1.3% | |
| 2001930534 | 3093 | 1.3% | |
| 2000035890 | 2973 | 1.2% | |
| 2001930798 | 2969 | 1.2% | |
| 2000038634 | 2858 | 1.2% | |
| 2001930812 | 2831 | 1.2% | |
| 2000035692 | 2757 | 1.1% | |
| Other values (304) | 101809 | 42.0% |
| Value | Count | Frequency (%) | |
| 2000035090 | 11 | < 0.1% | |
| 2000035110 | 12 | < 0.1% | |
| 2000035130 | 1 | < 0.1% | |
| 2000035140 | 69 | < 0.1% | |
| 2000035162 | 20 | < 0.1% | |
| 2000035194 | 1525 | 0.6% | |
| 2000035216 | 1 | < 0.1% | |
| 2000035230 | 126 | 0.1% | |
| 2000035232 | 616 | 0.3% | |
| 2000035252 | 1172 | 0.5% |
| Value | Count | Frequency (%) | |
| 2.000800023e+11 | 327 | 0.1% | |
| 2002034879 | 17 | < 0.1% | |
| 2002026609 | 2 | < 0.1% | |
| 2002025661 | 4137 | 1.7% | |
| 2002025613 | 77 | < 0.1% | |
| 2002025611 | 627 | 0.3% | |
| 2002025609 | 675 | 0.3% | |
| 2002025607 | 4215 | 1.7% | |
| 2002025275 | 4691 | 1.9% | |
| 2002024829 | 88 | < 0.1% |
| Distinct | 1819 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 60 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21249378.92 |
|---|---|
| Minimum | 0 |
| Maximum | 99294283 |
| Zeros | 55854 |
| Zeros (%) | 23.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 105199 |
| median | 1126648 |
| Q3 | 39513543 |
| 95-th percentile | 79601286 |
| Maximum | 99294283 |
| Range | 99294283 |
| Interquartile range (IQR) | 39408344 |
Descriptive statistics
| Standard deviation | 29510096.52 |
|---|---|
| Coefficient of variation (CV) | 1.388751014 |
| Kurtosis | -0.05956922076 |
| Mean | 21249378.92 |
| Median Absolute Deviation (MAD) | 1126648 |
| Skewness | 1.164314481 |
| Sum | 5.152953139e+12 |
| Variance | 8.708457964e+14 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 55854 | 23.0% | |
| 1126631 | 16339 | 6.7% | |
| 71479207 | 15444 | 6.4% | |
| 39513543 | 11879 | 4.9% | |
| 5757676 | 9371 | 3.9% | |
| 1125399 | 5720 | 2.4% | |
| 1126022 | 5479 | 2.3% | |
| 26635687 | 4281 | 1.8% | |
| 5757665 | 3899 | 1.6% | |
| 1126648 | 3301 | 1.4% | |
| 16397235 | 3004 | 1.2% | |
| 70639962 | 2578 | 1.1% | |
| 105638 | 2565 | 1.1% | |
| 43490931 | 2486 | 1.0% | |
| 26644096 | 2351 | 1.0% | |
| 79601286 | 2332 | 1.0% | |
| 1126016 | 2302 | 0.9% | |
| 73116035 | 2291 | 0.9% | |
| 186424 | 2236 | 0.9% | |
| 97728197 | 2148 | 0.9% | |
| 105199 | 1944 | 0.8% | |
| 31157965 | 1917 | 0.8% | |
| 160212 | 1863 | 0.8% | |
| 186683 | 1855 | 0.8% | |
| 98098048 | 1810 | 0.7% | |
| Other values (1794) | 77250 | 31.8% |
| Value | Count | Frequency (%) | |
| 0 | 55854 | 23.0% | |
| 59625 | 9 | < 0.1% | |
| 83262 | 455 | 0.2% | |
| 103094 | 1652 | 0.7% | |
| 105182 | 1030 | 0.4% | |
| 105199 | 1944 | 0.8% | |
| 105207 | 455 | 0.2% | |
| 105213 | 1194 | 0.5% | |
| 105236 | 1182 | 0.5% | |
| 105457 | 164 | 0.1% |
| Value | Count | Frequency (%) | |
| 99294283 | 5 | < 0.1% | |
| 99149316 | 2 | < 0.1% | |
| 98933686 | 25 | < 0.1% | |
| 98770511 | 4 | < 0.1% | |
| 98768158 | 2 | < 0.1% | |
| 98288783 | 4 | < 0.1% | |
| 98100331 | 1 | < 0.1% | |
| 98098048 | 1810 | 0.7% | |
| 98061051 | 2 | < 0.1% | |
| 97894760 | 6 | < 0.1% |
rodvag
Real number (ℝ≥0)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66.14466171 |
|---|---|
| Minimum | 20 |
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 60 |
| median | 60 |
| Q3 | 60 |
| 95-th percentile | 96 |
| Maximum | 99 |
| Range | 79 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.49677929 |
|---|---|
| Coefficient of variation (CV) | 0.2191677895 |
| Kurtosis | 1.309235417 |
| Mean | 66.14466171 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.8915704381 |
| Sum | 16043983 |
| Variance | 210.1566098 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 60 | 176277 | 72.7% | |
| 96 | 35570 | 14.7% | |
| 70 | 18510 | 7.6% | |
| 90 | 4141 | 1.7% | |
| 20 | 3060 | 1.3% | |
| 40 | 2662 | 1.1% | |
| 93 | 1012 | 0.4% | |
| 95 | 542 | 0.2% | |
| 92 | 532 | 0.2% | |
| 87 | 252 | 0.1% | |
| 99 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20 | 3060 | 1.3% | |
| 40 | 2662 | 1.1% | |
| 60 | 176277 | 72.7% | |
| 70 | 18510 | 7.6% | |
| 87 | 252 | 0.1% | |
| 90 | 4141 | 1.7% | |
| 92 | 532 | 0.2% | |
| 93 | 1012 | 0.4% | |
| 95 | 542 | 0.2% | |
| 96 | 35570 | 14.7% |
| Value | Count | Frequency (%) | |
| 99 | 1 | < 0.1% | |
| 96 | 35570 | 14.7% | |
| 95 | 542 | 0.2% | |
| 93 | 1012 | 0.4% | |
| 92 | 532 | 0.2% | |
| 90 | 4141 | 1.7% | |
| 87 | 252 | 0.1% | |
| 70 | 18510 | 7.6% | |
| 60 | 176277 | 72.7% | |
| 40 | 2662 | 1.1% |
| Distinct | 878 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 60 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38753544.79 |
|---|---|
| Minimum | 0 |
| Maximum | 99863723 |
| Zeros | 33571 |
| Zeros (%) | 13.8% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10891709 |
| median | 26649063 |
| Q3 | 68861216 |
| 95-th percentile | 93149858 |
| Maximum | 99863723 |
| Range | 99863723 |
| Interquartile range (IQR) | 57969507 |
Descriptive statistics
| Standard deviation | 32066395.53 |
|---|---|
| Coefficient of variation (CV) | 0.8274441914 |
| Kurtosis | -1.303849342 |
| Mean | 38753544.79 |
| Median Absolute Deviation (MAD) | 26488851 |
| Skewness | 0.3365886482 |
| Sum | 9.397695859e+12 |
| Variance | 1.028253723e+15 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 33571 | 13.8% | |
| 14788090 | 15974 | 6.6% | |
| 80298858 | 14538 | 6.0% | |
| 26635687 | 12968 | 5.3% | |
| 12776421 | 10788 | 4.4% | |
| 93149858 | 9105 | 3.8% | |
| 48134187 | 9097 | 3.8% | |
| 55472826 | 6417 | 2.6% | |
| 81195103 | 6404 | 2.6% | |
| 26644096 | 6353 | 2.6% | |
| 78465421 | 6090 | 2.5% | |
| 32214406 | 4857 | 2.0% | |
| 5757676 | 4846 | 2.0% | |
| 10891709 | 4619 | 1.9% | |
| 26648903 | 3778 | 1.6% | |
| 54998897 | 3485 | 1.4% | |
| 53067205 | 3467 | 1.4% | |
| 26648885 | 3179 | 1.3% | |
| 55565060 | 3032 | 1.3% | |
| 67680731 | 2898 | 1.2% | |
| 58146903 | 2853 | 1.2% | |
| 94421386 | 2732 | 1.1% | |
| 188110 | 2723 | 1.1% | |
| 53049555 | 2628 | 1.1% | |
| 98770511 | 2599 | 1.1% | |
| Other values (853) | 63498 | 26.2% |
| Value | Count | Frequency (%) | |
| 0 | 33571 | 13.8% | |
| 44474 | 146 | 0.1% | |
| 105207 | 1 | < 0.1% | |
| 105457 | 9 | < 0.1% | |
| 108708 | 1 | < 0.1% | |
| 109783 | 2 | < 0.1% | |
| 159953 | 7 | < 0.1% | |
| 160206 | 75 | < 0.1% | |
| 160212 | 1228 | 0.5% | |
| 161246 | 205 | 0.1% |
| Value | Count | Frequency (%) | |
| 99863723 | 8 | < 0.1% | |
| 99415491 | 831 | 0.3% | |
| 99029960 | 19 | < 0.1% | |
| 98770511 | 2599 | 1.1% | |
| 98113411 | 1 | < 0.1% | |
| 98112127 | 15 | < 0.1% | |
| 98108700 | 1 | < 0.1% | |
| 98103401 | 1 | < 0.1% | |
| 98098031 | 5 | < 0.1% | |
| 97990972 | 7 | < 0.1% |
tare_weight
Real number (ℝ≥0)
| Distinct | 217 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 240.8990184 |
|---|---|
| Minimum | 2 |
| Maximum | 588 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 220 |
| Q1 | 235 |
| median | 240 |
| Q3 | 246 |
| 95-th percentile | 265 |
| Maximum | 588 |
| Range | 586 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 14.85898982 |
|---|---|
| Coefficient of variation (CV) | 0.06168140459 |
| Kurtosis | 31.37937321 |
| Mean | 240.8990184 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 2.342966643 |
| Sum | 58432225 |
| Variance | 220.7895784 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 240 | 33104 | 13.6% | |
| 245 | 24998 | 10.3% | |
| 250 | 15644 | 6.4% | |
| 235 | 12138 | 5.0% | |
| 247 | 9899 | 4.1% | |
| 243 | 9256 | 3.8% | |
| 238 | 8889 | 3.7% | |
| 236 | 8396 | 3.5% | |
| 248 | 8124 | 3.3% | |
| 233 | 7514 | 3.1% | |
| 237 | 7148 | 2.9% | |
| 242 | 6485 | 2.7% | |
| 241 | 6363 | 2.6% | |
| 225 | 6086 | 2.5% | |
| 239 | 5671 | 2.3% | |
| 234 | 5354 | 2.2% | |
| 244 | 4700 | 1.9% | |
| 224 | 4679 | 1.9% | |
| 230 | 4201 | 1.7% | |
| 246 | 3722 | 1.5% | |
| 232 | 2951 | 1.2% | |
| 249 | 2908 | 1.2% | |
| 231 | 2163 | 0.9% | |
| 229 | 2147 | 0.9% | |
| 267 | 1830 | 0.8% | |
| Other values (192) | 38189 | 15.7% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 172 | 3 | < 0.1% | |
| 173 | 2 | < 0.1% | |
| 180 | 25 | < 0.1% | |
| 181 | 8 | < 0.1% | |
| 183 | 1 | < 0.1% | |
| 184 | 1 | < 0.1% | |
| 185 | 6 | < 0.1% | |
| 186 | 1 | < 0.1% | |
| 187 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 588 | 2 | < 0.1% | |
| 587 | 2 | < 0.1% | |
| 586 | 2 | < 0.1% | |
| 565 | 1 | < 0.1% | |
| 524 | 1 | < 0.1% | |
| 504 | 1 | < 0.1% | |
| 475 | 2 | < 0.1% | |
| 459 | 2 | < 0.1% | |
| 458 | 4 | < 0.1% | |
| 457 | 2 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | index_train | length | car_number | destination_esr | adm | danger | gruz | loaded | operation_car | operation_date | operation_st_esr | operation_st_id | operation_train | receiver | rodvag | rod_train | sender | ssp_station_esr | ssp_station_id | tare_weight | weight_brutto | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5 | NaN | 1.0 | 62826326 | 460005.0 | 20.0 | NaN | 161170.0 | NaN | 10.0 | 2020-07-16 06:30:00 | 862409.0 | 2.001933e+09 | NaN | 0.0 | 60.0 | NaN | 14788090.0 | NaN | NaN | 241.0 | NaN |
| 1 | 19 | NaN | 1.0 | 62845078 | 18502.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 13:39:00 | 872701.0 | 2.001931e+09 | NaN | 1125399.0 | 60.0 | NaN | 80298858.0 | NaN | NaN | 245.0 | NaN |
| 2 | 22 | NaN | 1.0 | 62844568 | 986103.0 | 20.0 | NaN | 161147.0 | NaN | 10.0 | 2020-07-16 14:08:00 | 862803.0 | 2.001931e+09 | NaN | 1126631.0 | 60.0 | NaN | 14788090.0 | NaN | NaN | 245.0 | NaN |
| 3 | 27 | NaN | 1.0 | 62846316 | 592204.0 | 20.0 | NaN | 161043.0 | NaN | 10.0 | 2020-07-16 15:12:00 | 863702.0 | 2.001931e+09 | NaN | 5757665.0 | 60.0 | NaN | 32214406.0 | NaN | NaN | 249.0 | NaN |
| 4 | 35 | NaN | 1.0 | 62843222 | 986103.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 15:04:00 | 863007.0 | 2.001933e+09 | NaN | 1126631.0 | 60.0 | NaN | 14788090.0 | NaN | NaN | 245.0 | NaN |
| 5 | 39 | NaN | 1.0 | 62843115 | 986103.0 | 20.0 | NaN | 161185.0 | NaN | 10.0 | 2020-07-16 16:19:00 | 865604.0 | 2.001931e+09 | NaN | 1126631.0 | 60.0 | NaN | 14788090.0 | NaN | NaN | 245.0 | NaN |
| 6 | 50 | NaN | 1.0 | 62842943 | 986103.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 15:04:00 | 863007.0 | 2.001933e+09 | NaN | 1126631.0 | 60.0 | NaN | 14788090.0 | NaN | NaN | 245.0 | NaN |
| 7 | 51 | NaN | 1.0 | 62844311 | 76404.0 | 20.0 | NaN | 161113.0 | NaN | 10.0 | 2020-07-16 10:55:00 | 863007.0 | 2.001933e+09 | NaN | 39513543.0 | 60.0 | NaN | 26635687.0 | NaN | NaN | 245.0 | NaN |
| 8 | 52 | NaN | 1.0 | 62842778 | 986103.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 15:04:00 | 863007.0 | 2.001933e+09 | NaN | 1126631.0 | 60.0 | NaN | 14788090.0 | NaN | NaN | 245.0 | NaN |
| 9 | 69 | NaN | 1.0 | 62843347 | 18502.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 14:22:00 | 872701.0 | 2.001931e+09 | NaN | 1125399.0 | 60.0 | NaN | 80298858.0 | NaN | NaN | 245.0 | NaN |
Last rows
| df_index | index_train | length | car_number | destination_esr | adm | danger | gruz | loaded | operation_car | operation_date | operation_st_esr | operation_st_id | operation_train | receiver | rodvag | rod_train | sender | ssp_station_esr | ssp_station_id | tare_weight | weight_brutto | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 242549 | 4189827 | NaN | 1.0 | 62817580 | 970406.0 | 20.0 | NaN | 161170.0 | NaN | 10.0 | 2020-07-16 15:19:00 | 871802.0 | 2.001934e+09 | NaN | 98098048.0 | 60.0 | NaN | 93149858.0 | NaN | NaN | 249.0 | NaN |
| 242550 | 4189845 | NaN | 1.0 | 62818489 | 967808.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 16:04:00 | 862108.0 | 2.001931e+09 | NaN | 1126163.0 | 60.0 | NaN | 93149858.0 | NaN | NaN | 249.0 | NaN |
| 242551 | 4189847 | NaN | 1.0 | 62818125 | 967808.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 16:04:00 | 862108.0 | 2.001931e+09 | NaN | 1126163.0 | 60.0 | NaN | 93149858.0 | NaN | NaN | 249.0 | NaN |
| 242552 | 4189849 | NaN | 1.0 | 62818307 | 985702.0 | 20.0 | NaN | 161113.0 | NaN | 10.0 | 2020-07-16 14:38:00 | 863007.0 | 2.001933e+09 | NaN | 461379.0 | 60.0 | NaN | 27605317.0 | NaN | NaN | 248.0 | NaN |
| 242553 | 4189851 | NaN | 1.0 | 62817937 | 986103.0 | 20.0 | NaN | 161185.0 | NaN | 10.0 | 2020-07-16 06:03:00 | 864705.0 | 2.001934e+09 | NaN | 1126631.0 | 60.0 | NaN | 55472826.0 | NaN | NaN | 250.0 | NaN |
| 242554 | 4189871 | NaN | 1.0 | 62815741 | 76404.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 02:23:00 | 863007.0 | 2.001933e+09 | NaN | 39513543.0 | 60.0 | NaN | 54998897.0 | NaN | NaN | 249.0 | NaN |
| 242555 | 4189873 | NaN | 1.0 | 62815154 | 986103.0 | 20.0 | NaN | 161185.0 | NaN | 10.0 | 2020-07-16 06:03:00 | 864705.0 | 2.001934e+09 | NaN | 1126631.0 | 60.0 | NaN | 55472826.0 | NaN | NaN | 245.0 | NaN |
| 242556 | 4189884 | NaN | 1.0 | 62816756 | 967808.0 | 20.0 | NaN | 161128.0 | NaN | 10.0 | 2020-07-16 16:04:00 | 862108.0 | 2.001931e+09 | NaN | 1126163.0 | 60.0 | NaN | 93149858.0 | NaN | NaN | 250.0 | NaN |
| 242557 | 4189887 | NaN | 1.0 | 62816178 | 986103.0 | 20.0 | NaN | 161185.0 | NaN | 10.0 | 2020-07-16 06:03:00 | 864705.0 | 2.001934e+09 | NaN | 1126631.0 | 60.0 | NaN | 55472826.0 | NaN | NaN | 238.0 | NaN |
| 242558 | 4189902 | NaN | 1.0 | 62813852 | 592204.0 | 20.0 | NaN | 161043.0 | NaN | 10.0 | 2020-07-16 00:59:00 | 863100.0 | 2.001931e+09 | NaN | 5757665.0 | 60.0 | NaN | 43830663.0 | NaN | NaN | 247.0 | NaN |